package com.jww.dao.bill;

import com.jww.pojo.Bill;

import java.sql.Connection;
import java.sql.SQLException;
import java.util.List;

public interface BillDao {
    //根据产品名字和提供id查询订单总数
    public int getBillCount(Connection conn,String productName,int providerId,int isPayment) throws SQLException;

    //查询订单信息列表
    public List<Bill> getBillList(Connection conn,String productName,int providerId,int isPayment,int currentPageNo,int pageSize) throws SQLException;

    //添加订单
    public int addBill(Connection conn, Bill bill) throws SQLException;

    //查看订单
    public Bill getBillId(Connection conn, int id) throws SQLException;

    //修改订单
    public int updateBill(Connection conn, Bill bill) throws SQLException;

    //根据billCode查询bill
    public Bill getBillCode(Connection conn, String billCode) throws SQLException;

    //删除订单信息
    public int deleteBill(Connection conn, int id) throws SQLException;
}
